Report output field and column headings
This section identifies the fields or column headings associated with each historical report template.
Note:
Fields and column headings in this section that are identified with an asterisk (*) are also the Fathom-supplied defaults associated with each report type.
AppServer Application Profile
Table 2–2 identifies the AppServer Application Profile column headings.
Table 2–2: AppServer Application Profile column headings
|
Run Count*
|
Average Request Duration (ms)
|
Maximum Request Duration (ms)
|
|
Return Code Success
|
Return Code Error
|
Return Code Quit
|
|
Return Code Stop
|
Sample Count
|
–
|
AppServer Performance
Table 2–3, Table 2–4, and Table 2–5 identify the column headings for an AppServer Performance graphical report.
Table 2–3: AppServer Client Activity column headings
|
Average Active Clients*
|
Maximum Active Clients
|
Client Requests
|
|
Average Client Requests
|
Maximum Client Requests
|
Sample Count
|
Table 2–4: AppServer Broker Activity column headings
|
Requests Completed
|
Requests Queued
|
Requests Queued %
|
|
*Average Request Duration (ms)
|
Maximum Request Duration (ms)
|
Average CPU Usage %
|
|
Maximum CPU Usage %
|
Average Memory Usage (k)
|
Maximum Memory Usage (k)
|
|
Sample Count
|
–
|
–
|
Table 2–5: AppServer Activity column headings
|
Average Pool CPU Usage %
|
Maximum Pool CPU
Usage %
|
Average Pool Memory Usage % (k)
|
|
Maximum Pool Memory Usage (k)
|
*Average Busy Server Count
|
Maximum Busy Server Count
|
|
Average Busy Server Time (ms)
|
Average Locked Server Count
|
Maximum Locked Server Count
|
|
Average Locked Server Time (ms)
|
Sample Count
|
–
|
Database After-Imaging
Table 2–6 identifies the column headings for a Database After-Imaging graphical report.
Table 2–6: Database After-Imaging column headings
|
ActLog_AIBBufWaits
|
ActLog_AIByteWrites
|
ActLog_AINoBufAvail
|
|
ActLog_AIPartialWrites
|
ActLog_AIRecWrites
|
ActLog_AITotWrites*
|
|
ActLog_AIWWrites*
|
–
|
–
|
Database Area Status
Table 2–7 identifies the column headings for a Database Area Status graphical report.
Table 2–7: Database Area Status column headings
|
Sample Count
|
Total Blocks
|
Hi Water Mark*
|
|
Free Blocks
|
RM Blocks
|
Blocks Available*
|
|
Pct. Blocks Available
|
–
|
–
|
Database Before-Imaging
Table 2–8 identifies the fields for a Database Before-Imaging graphical report.
Table 2–8: Database Before-Imaging fields
|
ActLog_BITotReads
|
ActLog_BITotWrites*
|
ActLog_BIWWrites*
|
|
ActSum_BIReads
|
ActSum_BIWrites
|
ActLog_BIBBufWaits
|
|
ActLog_BIByteReads
|
ActLog_BIByteWrites
|
ActLog_BIEBufWaits
|
|
ActLog_BIPartialWrites
|
ActLog_BIRecReads
|
ActLog_BIRecWrites
|
Database Checkpointing
Table 2–9 identifies the column headings for a Database Checkpointing graphical report.
Table 2–9: Database Checkpointing column headings
|
Sample Count
|
Checkpoint Length*
|
Buffer Scanned
|
|
Checkpoint Queue
|
APW Queue
|
Buffers Flushed*
|
Database Details
Table 2–10 identifies the fields for a Database Details graphical report.
Table 2–10: Database Details fields
|
ActBuf_Flushed
|
ActBuf_LogicReads*
|
ActBuf_LogicWrites*
|
|
ActSum_DbReads
|
ActSum_DbWrites
|
ActRec_RecRead
|
|
ActLog_BITotWrites
|
ActLog_BIWWrites
|
ActAPW_APWEnq
|
|
ActIOType_IdxReads
|
ActIOType_IdxWrites
|
ActAPW_APWQWrites
|
|
ActAPW_BufsCkpt
|
ActAPW_BufsScanned
|
ActAPW_CkptQWrites
|
|
ActAPW_Ckpts
|
ActAPW_DBWrites
|
ActAPW_Marked
|
|
ActAPW_ScanCycles
|
ActAPW_ScanWrites
|
ActAPW_TotDBWrites
|
|
ActBuf_Deferred
|
ActBuf_OSReads
|
ActBuf_OSWrites
|
|
ActIdx_Create
|
ActIdx_Delete
|
ActIdx_Find
|
|
ActIdx_Free
|
ActIdx_Remove
|
ActIdx_Splits
|
|
ActLock_CancelReq
|
ActLock_Downgrade
|
ActLock_ExclFind
|
|
ActLock_ExclLock
|
ActLock_ExclReq
|
ActLock_ExclWait
|
|
ActLock_RecGetLock
|
ActLock_RecGetReq
|
ActLock_RecGetWait
|
|
ActLock_ShrFind
|
ActLock_ShrLock
|
ActLock_ShrReq
|
|
ActLock_ShrWait
|
ActLock_UpgLock
|
ActLock_UpgReq
|
|
ActLock_UpgWait
|
ActRec_ByteCreate
|
ActRec_ByteDel
|
|
ActRec_ByteRead
|
ActRec_ByteUpd
|
ActRec_FragCreate
|
|
ActRec_FragDel
|
ActRec_FragRead
|
ActRec_FragUpd
|
|
ActRec_RecCreate
|
ActRec_RecDel
|
ActRec_RecLock
|
|
ActRec_RecUpd
|
ActRec_RecWait
|
ActSum_AllocNewRm
|
|
ActSum_BytesAlloc
|
ActSum_Examined
|
ActSum_FromFree
|
|
ActSum_FromRm
|
ActSum_Removed
|
ActSum_RetFree
|
|
ActSum_TakeFree
|
ActSum_AiWrites
|
ActSum_BiReads
|
|
ActSum_Commits
|
ActSum_DBAccesses
|
ActSum_DbExtend
|
|
ActSum_Undos
|
ActLog_AIBBufWaits
|
ActLog_AIByteWrites
|
|
ActLog_AINoBufAvail
|
ActLog_AiPartialWrites
|
ActLog_AIRecWrites
|
|
ActLog_AITotWrites
|
ActLog_AIWWrites
|
ActLog_BIBufWaits
|
|
ActLog_BIByteReads
|
ActLog_BIByteWrites
|
ActLog_BIEBufWaits
|
|
ActLog_BIPartialWrites
|
ActLog_BIRecReads
|
ActLog_BIRecWrites
|
|
ActLog_BITotReads
|
ActIOType_AiReads
|
ActIOType_AiWrites
|
|
ActIOType_BiReads
|
ActIOType_BiWrites
|
ActIOType_DataReads
|
|
ActIOType_DataWrites
|
–
|
–
|
Database Disk Information
Table 2–11 identifies the fields for a Database Disk Information graphical report.
Table 2–11: Database Disk Information fields
|
ActSum_DbReads
|
ActSum_DbWrites
|
ActAPW_DBWrites*
|
|
ActAPW_TotDBWrites*
|
ActSum_DbAccesses
|
ActSum_DbExtend
|
|
ActIOType_AiReads
|
ActIOType_AiWrites
|
ActIOType_BiReads
|
|
ActIOType_BiWrites
|
ActIOType_DataReads
|
ActIOType_DataWrites
|
|
ActIOType_IdxReads
|
ActIOType_IdxWrites
|
–
|
Database Index Analysis
Table 2–12 identifies the column headings for a Database Index Analysis graphical report.
Table 2–12: Database Index Analysis column headings
|
Sample Count
|
Max Block Count
|
Min Block Count
|
|
Avg Block Count
|
Max Byte Count
|
Min Byte Count
|
|
Avg Byte Count
|
Max Util Percent
|
Min Util Percent
|
|
Avg Util Percent*
|
Max Level Count
|
Min Level Count
|
|
Avg Level Count
|
–
|
–
|
Database Index Usage
Table 2–13 identifies the column headings for a Database Index Usage graphical report.
Table 2–13: Database Index Utilization column headings
|
Index Reads*
|
Index Splits
|
Index Creates
|
|
Index Deletes
|
–
|
–
|
Database Locking
Table 2–14 identifies the fields for a Database Locking graphical report.
Table 2–14: Database Locking fields
|
ActLock_CancelReq
|
ActLock_Downgrade
|
ActLock_ExclFind
|
|
ActLock_ExclLock
|
ActLock_ExclReq
|
ActLock_ExclWait*
|
|
ActLock_RecGetLock
|
ActLock_RecGetReq
|
ActLock_RecGetWait*
|
|
ActLock_ShrFind
|
ActLock_ShrLock
|
ActLock_ShrReq
|
|
ActLock_ShrWait*
|
ActLock_UpgLock
|
ActLock_UpgReq
|
|
ActLock_UpgWait*
|
–
|
–
|
Database Buffer I/O
Table 2–15 identifies the fields for a Database Buffer I/O graphical report.
Table 2–15: Database Memory Usage fields
|
ActBuf_Flushed
|
ActBuf_LogicReads*
|
ActBuf_LogicWrites
|
|
ActBuf_Deferred
|
ActBuf_OSReads*
|
ActLog_AIBBufWaits
|
|
ActLog_AINoBufAvail
|
ActLog_AIPartialWrites
|
ActLog_BIBBufWaits
|
|
ActLog_BIEBPartialWaits
|
ActLog_BIPartialWrites
|
–
|
Database Record Information
Table 2–16 identifies the fields for a Database Record Information graphical report.
Table 2–16: Database Record Information fields
|
ActRec_RecRead
|
ActRec_RecCreate*
|
ActRec_RecDel*
|
|
ActRec_ByteRead
|
ActRec_ByteUpd
|
ActRec_FragCreate
|
|
ActRec_FragDel
|
ActRec_FragRead
|
ActRec_FragUpd
|
|
ActRec_RecCreate
|
ActRec_RecDel
|
ActRec_RecLock*
|
|
ActRec_RecUpd*
|
ActRec_RecWait
|
ActRec_ByteCreate
|
|
ActRec_ByteDel
|
–
|
–
|
Database Server Activity
Table 2–17 identifies the column headings for a Database Server Activity graphical report.
Table 2–17: Database Server Activity column headings
|
Messages Received
|
Messages Sent
|
Bytes Received
|
|
Bytes Sent
|
Records Received*
|
Records Sent*
|
|
Min Users
|
Max Users
|
Avg Users
|
Database Summary
Table 2–18 identifies the fields for a Database Summary graphical report.
Table 2–18: Database Summary fields
|
ActBuf_Flushed
|
ActBuf_LogicReads*
|
ActBuf_LogicWrites*
|
|
ActSum_DbReads
|
ActSum_DbWrites
|
ActRec_RecRead
|
|
ActLog_BITotWrites
|
ActLog_BIWWrites
|
ActAPW_BufsCkpt
|
|
ActBuf_OSReads
|
ActBuf_OSWrites
|
ActIdx_Create
|
|
ActIdx_Delete
|
ActIdx_Find
|
ActIdx_Free
|
|
AdxIdx_Remove
|
ActIdx_Splits
|
ActSum_Commits
|
|
ActSum_DbAccesses*
|
ActSum_DbExtend
|
ActIOType_DataReads
|
|
ActIOType_IdxReads
|
ActIOType_IdxWrites
|
–
|
Database Table Analysis
Table 2–19 identifies the column headings for a Database Table Analysis graphical report.
Table 2–19: Database Table Analysis column headings
|
Sample Count
|
Max Record Count
|
Min Record Count
|
|
Ave Record Count*
|
Max # of Bytes
|
Min # of Bytes
|
|
Ave # of Bytes
|
Max # of Fragments
|
Min # of Fragments
|
|
Ave # of Fragments
|
Max Scatter Factor
|
Min Scatter Factor
|
|
Ave Scatter Factor
|
–
|
–
|
Database Table Usage
Table 2–20 identifies the column headings for a Database Table Usage graphical report.
Table 2–20: Database Table Usage column headings
|
Record Reads*
|
Record Updates*
|
Record Creates*
|
|
Record Deletes*
|
–
|
–
|
CPU Summary
Table 2–21 identifies the fields for a CPU Summary graphical report.
Table 2–21: CPU Summary fields
|
CPU_User*
|
CPU_System*
|
CPU_Wait*
|
|
CPU_Idle
|
–
|
–
|
File Summary
Table 2–22 identifies the column headings for a File Summary graphical report.
Table 2–22: File Summary column headings
|
Sample Count
|
Average File Size (k)*
|
Minimum Size (k)
|
|
Maximum Size (k)
|
–
|
–
|
Network Activity
Table 2–23 identifies the column headings for a Network Activity graphical report.
Table 2–23: Network Activity column headings
|
Sample Count
|
Avg. Response*
|
–
|
System Disk Device Activity
Table 2–24 identifies the column headings for a System Disk Device Activity graphical report.
Table 2–24: System Disk Device Activity column headings
|
Sample Count
|
Pct Busy*
|
Avg Queue
|
|
Avg Wait
|
Avg Serve
|
Minimum Busy
|
|
Maximum Busy
|
–
|
–
|
System Filesystem Usage
Table 2–25 identifies the column headings for a System Filesystem Usage graphical report.
Table 2–25: System Filesystem Usage column headings
|
Sample Count
|
Capacity
|
Pct Used*
|
|
Current Available
|
Maximum Available
|
Minimum Available
|
System Memory Summary
Table 2–26 identifies the column headings for a System Memory Summary graphical report.
Table 2–26: System Memory Summary column headings
|
Max System Memory
|
Min System Memory
|
Max Virtual Memory
|
|
Min Virtual Memory
|
Max Free System Memory
|
Min Free System Memory
|
|
Max Free Virtual Memory
|
Min Free Virtual Memory
|
Pages In
|
|
Pages Out
|
–
|
–
|
WebSpeed Application Profile
Table 2–27 identifies the column headings for a WebSpeed Application Profile graphical report.
Table 2–27: WebSpeed Application Profile column headings
|
Run Count*
|
Average Request Duration (ms)
|
Maximum Request Duration (ms)
|
|
Sample Count
|
–
|
–
|
WebSpeed Performance
Table 2–28, Table 2–29, and Table 2–30 identify the column headings for a WebSpeed Performance graphical report.
Table 2–28: WebSpeed Client Activity column headings
|
Average Active Clients*
|
Maximum Active Clients
|
Client Requests
|
|
Average Client Requests
|
Maximum Client Requests
|
Sample Count
|
Table 2–29: WebSpeed Broker Activity column headings
|
Requests Completed
|
Requests Queued
|
Requests Queued %
|
|
*Average Request Duration (ms)
|
Maximum Request Duration (ms)
|
Average CPU Usage %
|
|
Maximum CPU Usage %
|
Average Memory Usage (k)
|
Maximum Memory Usage (k)
|
|
Sample Count
|
–
|
–
|
Table 2–30: WebSpeed Server Activity column headings
|
Average Pool CPU Usage %
|
Maximum Pool CPU Usage %
|
Average Pool Memory Usage (k)
|
|
Maximum Pool Memory Usage (k)
|
*Average Busy Server Count
|
Maximum Busy Server Count
|
|
Average Busy Server Time (ms)
|
Average Locked Server Count
|
Maximum Locked Server Count
|
|
Average Locked Server Time(ms)
|
Sample Count
|
–
|